package com.css.fxfzypg.modules.baseData.repository;

import com.alibaba.fastjson.JSONObject;
import com.css.fxfzypg.modules.baseData.queryParams.HosPeoQueryParams;
import com.css.fxfzypg.modules.baseData.entity.HosPeoEntity;

import java.sql.Timestamp;
import java.util.List;

/**
 * @author y1fan
 * @create 2022-08-23 12:49
 */
public interface HosPeoRepository {


    int saveHosPeo(HosPeoEntity hosPeoEntity);

    HosPeoEntity fingHosPeoById(String id);

    HosPeoEntity fingHosPeoBydivision(String provinceId,String cityId,String prefectureId);

    int updateHosPeo(HosPeoEntity hosPeoEntity);

    JSONObject getAllHosPerByParams(HosPeoQueryParams queryParams, int curPage, int pageSize);

    void deleteHosPeo(String id, String userId, Timestamp currentTimestamp);

    List<HosPeoEntity> exportExcel();

    void importExcel(List<HosPeoEntity> hosPeoEntities);

    HosPeoEntity findHosPeo(String province,String city,String prefecture);

    void delete(HosPeoEntity hosPeoEntity);

    Integer countByCounty(String name, String city, String county);
    Integer countByCity(String name, String city);
    Integer countByProvince(String name);

    Integer countByProvinceAndYear(String provinceName, String taskYear);
}
